/*     */ package com.yc.web.export;
/*     */ 
/*     */ import com.yc.comm.QueryContants;
/*     */ import com.yc.dao.model.AcdcDistributionBO;
/*     */ import com.yc.dao.model.AirconditionBO;
/*     */ import com.yc.dao.model.AntennaFeederBO;
/*     */ import com.yc.dao.model.BTSNewBO;
/*     */ import com.yc.dao.model.BathunderBO;
/*     */ import com.yc.dao.model.DynamoBO;
/*     */ import com.yc.dao.model.EnvMontorBO;
/*     */ import com.yc.dao.model.FireExtinGuisherBO;
/*     */ import com.yc.dao.model.GeographicalenvBo;
/*     */ import com.yc.dao.model.IronTowerBO;
/*     */ import com.yc.dao.model.MachineRoomBO;
/*     */ import com.yc.dao.model.MagnifierBO;
/*     */ import com.yc.dao.model.MainssupplyBO;
/*     */ import com.yc.dao.model.PowerBoxBO;
/*     */ import com.yc.dao.model.PowerSupplyBO;
/*     */ import com.yc.dao.model.StoragebatteryBO;
/*     */ import com.yc.dao.model.TrafficInfoBO;
/*     */ import com.yc.dao.model.TransfersBO;
/*     */ import com.yc.dao.model.TransformerBO;
/*     */ import java.text.SimpleDateFormat;
/*     */ import java.util.Date;
/*     */ import java.util.List;
/*     */ import org.apache.poi.hssf.usermodel.HSSFCell;
/*     */ import org.apache.poi.hssf.usermodel.HSSFRow;
/*     */ import org.apache.poi.hssf.usermodel.HSSFSheet;
/*     */ 
/*     */ public class ExportUtil
/*     */ {
/*     */   public static void wirteToExcel(HSSFSheet sheet, List list, int tableNo)
/*     */   {
/*  35 */     switch (tableNo)
/*     */     {
/*     */     case 1:
/*  38 */       wirteToExcelForBts(sheet, list);
/*  39 */       break;
/*     */     case 2:
/*  41 */       wirteToExcelForMag(sheet, list);
/*  42 */       break;
/*     */     case 3:
/*  44 */       wirteToExcelForPowerBox(sheet, list);
/*  45 */       break;
/*     */     case 4:
/*  47 */       wirteToExcelForStorageBattery(sheet, list);
/*  48 */       break;
/*     */     case 5:
/*  50 */       wirteToExcelForAircondition(sheet, list);
/*  51 */       break;
/*     */     case 6:
/*  53 */       wirteToExcelForFireExtinGuisher(sheet, list);
/*  54 */       break;
/*     */     case 7:
/*  56 */       wirteToExcelForBathunder(sheet, list);
/*  57 */       break;
/*     */     case 8:
/*  59 */       wirteToExcelForEnvMontor(sheet, list);
/*  60 */       break;
/*     */     case 9:
/*  62 */       wirteToExcelForDynamo(sheet, list);
/*  63 */       break;
/*     */     case 10:
/*  65 */       wirteToExcelForAcdcDistribution(sheet, list);
/*  66 */       break;
/*     */     case 11:
/*  68 */       wirteToExcelForTransformer(sheet, list);
/*  69 */       break;
/*     */     case 12:
/*  71 */       wirteToExcelForTransfers(sheet, list);
/*  72 */       break;
/*     */     case 13:
/*  74 */       wirteToExcelForMainssupply(sheet, list);
/*  75 */       break;
/*     */     case 14:
/*  77 */       wirteToExcelForAntennaFeeder(sheet, list);
/*  78 */       break;
/*     */     case 15:
/*  80 */       wirteToExcelForIronTower(sheet, list);
/*  81 */       break;
/*     */     case 16:
/*  83 */       wirteToExcelForMachineRoom(sheet, list);
/*  84 */       break;
/*     */     case 17:
/*  86 */       wirteToExcelForPowerSupply(sheet, list);
/*  87 */       break;
/*     */     case 18:
/*  89 */       wirteToExcelForTrafficInfo(sheet, list);
/*  90 */       break;
/*     */     case 19:
/*  92 */       wirteToExcelForEnv(sheet, list);
/*  93 */       break;
/*     */     default:
/*  95 */       wirteToExcelForBts(sheet, list);
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForBts(HSSFSheet sheet, List list)
/*     */   {
/* 101 */     int count = list.size();
/* 102 */     if (count > 0)
/*     */     {
/* 104 */       String[] title = QueryContants.BTS_TITLE;
/* 105 */       HSSFRow rowTitle = sheet.createRow(0);
/* 106 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 108 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 110 */       int columnCount = 0;
/* 111 */       for (int i = 0; i < count; i++)
/*     */       {
/* 113 */         BTSNewBO bo = (BTSNewBO)list.get(i);
/* 114 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 115 */         columnCount = 0;
/* 116 */         row.createCell((short)columnCount++).setCellValue(bo.getId());
/* 117 */         row.createCell((short)columnCount++).setCellValue(bo.getBtscode());
/* 118 */         row.createCell((short)columnCount++).setCellValue(bo.getBtsname());
/* 119 */         row.createCell((short)columnCount++).setCellValue(bo.getFrequency());
/* 120 */         row.createCell((short)columnCount++).setCellValue(bo.getBSC());
/* 121 */         row.createCell((short)columnCount++).setCellValue(bo.getManufacturer());
/* 122 */         row.createCell((short)columnCount++).setCellValue(bo.getCabinet());
/* 123 */         row.createCell((short)columnCount++).setCellValue(bo.getPrimdevicetype());
/* 124 */         row.createCell((short)columnCount++).setCellValue(bo.getBtscfg());
/* 125 */         row.createCell((short)columnCount++).setCellValue(bo.getFrequencyNum());
/* 126 */         row.createCell((short)columnCount++).setCellValue(bo.getCombinerType());
/* 127 */         row.createCell((short)columnCount++).setCellValue(bo.getCombinerNum());
/* 128 */         row.createCell((short)columnCount++).setCellValue(bo.getPrimContrmodel());
/* 129 */         row.createCell((short)columnCount++).setCellValue(bo.getPrimContrNum());
/* 130 */         row.createCell((short)columnCount++).setCellValue(bo.getPowerPanelType());
/* 131 */         row.createCell((short)columnCount++).setCellValue(bo.getPowerPanelNum());
/* 132 */         row.createCell((short)columnCount++).setCellValue(bo.getPowerType());
/* 133 */         row.createCell((short)columnCount++).setCellValue(bo.getEle2Mnum());
/* 134 */         row.createCell((short)columnCount++).setCellValue(Contants.fresh.format(bo.getRegisttime()));
/* 135 */         row.createCell((short)columnCount++).setCellValue(bo.getAntennaType());
/* 136 */         row.createCell((short)columnCount++).setCellValue(bo.getAntennaFac());
/* 137 */         row.createCell((short)columnCount++).setCellValue(bo.getAntennaNum());
/* 138 */         row.createCell((short)columnCount++).setCellValue(bo.getAntennaGain());
/* 139 */         row.createCell((short)columnCount++).setCellValue(bo.getAntennaDirect());
/* 140 */         row.createCell((short)columnCount++).setCellValue(bo.getAntennaPolar());
/* 141 */         row.createCell((short)columnCount++).setCellValue(bo.getAntennaHeight());
/* 142 */         row.createCell((short)columnCount++).setCellValue(bo.getAntennaPre());
/* 143 */         row.createCell((short)columnCount++).setCellValue(bo.getAntennaAngle());
/* 144 */         row.createCell((short)columnCount++).setCellValue(bo.getAntennaPitchAngle());
/* 145 */         row.createCell((short)columnCount++).setCellValue(bo.getFeederType());
/* 146 */         row.createCell((short)columnCount++).setCellValue(bo.getOther1());
/* 147 */         row.createCell((short)columnCount++).setCellValue(bo.getOther2());
/* 148 */         row.createCell((short)columnCount++).setCellValue(bo.getOther3());
/* 149 */         row.createCell((short)columnCount++).setCellValue(bo.getOther4());
/* 150 */         row.createCell((short)columnCount++).setCellValue(bo.getIDUType());
/* 151 */         row.createCell((short)columnCount++).setCellValue(bo.getIDUNum());
/* 152 */         row.createCell((short)columnCount++).setCellValue(bo.getODUType());
/* 153 */         row.createCell((short)columnCount++).setCellValue(bo.getODUNum());
/* 154 */         row.createCell((short)columnCount++).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 155 */         row.createCell((short)columnCount++).setCellValue(bo.getMemo());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForMag(HSSFSheet sheet, List list)
/*     */   {
/* 163 */     int count = list.size();
/* 164 */     if (count > 0)
/*     */     {
/* 166 */       String[] title = QueryContants.MAGNIFIER_TITLE;
/* 167 */       HSSFRow rowTitle = sheet.createRow(0);
/* 168 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 170 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 172 */       for (int i = 0; i < count; i++)
/*     */       {
/* 174 */         MagnifierBO bo = (MagnifierBO)list.get(i);
/* 175 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 176 */         row.createCell((short)0).setCellValue(bo.getId());
/* 177 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 178 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 179 */         row.createCell((short)3).setCellValue(bo.getType());
/* 180 */         row.createCell((short)4).setCellValue(bo.getCapacity());
/* 181 */         row.createCell((short)5).setCellValue(bo.getManufacturer());
/* 182 */         row.createCell((short)6).setCellValue(bo.getNum());
/* 183 */         row.createCell((short)7).setCellValue(bo.getCellU());
/* 184 */         row.createCell((short)8).setCellValue(Contants.open.format(bo.getOpentime()));
/* 185 */         row.createCell((short)9).setCellValue(bo.getMaintenance());
/* 186 */         row.createCell((short)10).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 187 */         row.createCell((short)11).setCellValue(bo.getMemo());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForPowerBox(HSSFSheet sheet, List list)
/*     */   {
/* 194 */     int count = list.size();
/* 195 */     if (count > 0)
/*     */     {
/* 197 */       String[] title = QueryContants.POWERBOX_TITLE;
/* 198 */       HSSFRow rowTitle = sheet.createRow(0);
/* 199 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 201 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 203 */       for (int i = 0; i < count; i++)
/*     */       {
/* 205 */         PowerBoxBO bo = (PowerBoxBO)list.get(i);
/* 206 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 207 */         row.createCell((short)0).setCellValue(bo.getId());
/* 208 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 209 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 210 */         row.createCell((short)3).setCellValue(bo.getType());
/* 211 */         row.createCell((short)4).setCellValue(bo.getManufacturer());
/* 212 */         row.createCell((short)5).setCellValue(bo.getNum());
/* 213 */         row.createCell((short)6).setCellValue(bo.getDcvoltage());
/* 214 */         row.createCell((short)7).setCellValue(Contants.open.format(bo.getOpentime()));
/* 215 */         row.createCell((short)8).setCellValue(bo.getCommtype());
/* 216 */         row.createCell((short)9).setCellValue(bo.getCommcapacity());
/* 217 */         row.createCell((short)10).setCellValue(bo.getMonmodel());
/* 218 */         row.createCell((short)11).setCellValue(bo.getMonnum());
/* 219 */         row.createCell((short)12).setCellValue(bo.getMaintenance());
/* 220 */         row.createCell((short)13).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 221 */         row.createCell((short)14).setCellValue(bo.getMemo());
/* 222 */         row.createCell((short)15).setCellValue(bo.getPboxOutI());
/* 223 */         row.createCell((short)16).setCellValue(bo.getPboxNum());
/* 224 */         row.createCell((short)17).setCellValue(bo.getPboxWorkSta());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForStorageBattery(HSSFSheet sheet, List list)
/*     */   {
/* 231 */     int count = list.size();
/* 232 */     if (count > 0)
/*     */     {
/* 234 */       String[] title = QueryContants.STORAGEBATTERY_TITLE;
/* 235 */       HSSFRow rowTitle = sheet.createRow(0);
/* 236 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 238 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 240 */       for (int i = 0; i < count; i++)
/*     */       {
/* 242 */         StoragebatteryBO bo = (StoragebatteryBO)list.get(i);
/* 243 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 244 */         row.createCell((short)0).setCellValue(bo.getId());
/* 245 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 246 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 247 */         row.createCell((short)3).setCellValue(bo.getType());
/* 248 */         row.createCell((short)4).setCellValue(bo.getManufacturer());
/* 249 */         row.createCell((short)5).setCellValue(bo.getCapacity());
/* 250 */         row.createCell((short)6).setCellValue(bo.getGroupnum());
/* 251 */         row.createCell((short)7).setCellValue(bo.getBatterynum());
/* 252 */         row.createCell((short)8).setCellValue(bo.getVoltage());
/* 253 */         row.createCell((short)9).setCellValue(Contants.open.format(bo.getOpentime()));
/* 254 */         row.createCell((short)10).setCellValue(bo.getDischarge());
/* 255 */         row.createCell((short)11).setCellValue(bo.getMaintenance());
/* 256 */         row.createCell((short)12).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 257 */         row.createCell((short)13).setCellValue(bo.getMemo());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForAircondition(HSSFSheet sheet, List list)
/*     */   {
/* 264 */     int count = list.size();
/* 265 */     if (count > 0)
/*     */     {
/* 267 */       String[] title = QueryContants.AIRCONDITION_TITLE;
/* 268 */       HSSFRow rowTitle = sheet.createRow(0);
/* 269 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 271 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 273 */       int columCount = 0;
/* 274 */       for (int i = 0; i < count; i++)
/*     */       {
/* 276 */         columCount = 0;
/* 277 */         AirconditionBO bo = (AirconditionBO)list.get(i);
/* 278 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 279 */         row.createCell((short)columCount++).setCellValue(bo.getId());
/* 280 */         row.createCell((short)columCount++).setCellValue(bo.getBtscode());
/* 281 */         row.createCell((short)columCount++).setCellValue(bo.getBtsname());
/* 282 */         row.createCell((short)columCount++).setCellValue(bo.getType());
/* 283 */         row.createCell((short)columCount++).setCellValue(bo.getManufacturer());
/* 284 */         row.createCell((short)columCount++).setCellValue(bo.getCapacity());
/* 285 */         row.createCell((short)columCount++).setCellValue(bo.getNum());
/* 286 */         row.createCell((short)columCount++).setCellValue(Contants.open.format(bo.getOpentime()));
/* 287 */         row.createCell((short)columCount++).setCellValue(bo.getFence());
/* 288 */         row.createCell((short)columCount++).setCellValue(bo.getMaintenance());
/* 289 */         row.createCell((short)columCount++).setCellValue(Contants.fresh.format(new Date()));
/* 290 */         row.createCell((short)columCount++).setCellValue(bo.getMemo());
/* 291 */         row.createCell((short)columCount++).setCellValue(bo.getAircPowerType());
/* 292 */         row.createCell((short)columCount++).setCellValue(bo.getAircType());
/* 293 */         row.createCell((short)columCount++).setCellValue(bo.getAircInSideSize());
/* 294 */         row.createCell((short)columCount++).setCellValue(bo.getAircOutSideSize());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForFireExtinGuisher(HSSFSheet sheet, List list)
/*     */   {
/* 302 */     int count = list.size();
/* 303 */     if (count > 0)
/*     */     {
/* 305 */       String[] title = QueryContants.FIREEXTINGGUISHER_TITLE;
/* 306 */       HSSFRow rowTitle = sheet.createRow(0);
/* 307 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 309 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 311 */       for (int i = 0; i < count; i++)
/*     */       {
/* 313 */         FireExtinGuisherBO bo = (FireExtinGuisherBO)list.get(i);
/* 314 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 315 */         row.createCell((short)0).setCellValue(bo.getId());
/* 316 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 317 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 318 */         row.createCell((short)3).setCellValue(bo.getManufacturer());
/* 319 */         row.createCell((short)4).setCellValue(bo.getType());
/* 320 */         row.createCell((short)5).setCellValue(bo.getNum());
/* 321 */         row.createCell((short)6).setCellValue(bo.getInwarranty());
/* 322 */         row.createCell((short)7).setCellValue(bo.getMaintenance());
/* 323 */         row.createCell((short)8).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 324 */         row.createCell((short)9).setCellValue(bo.getMemo());
/* 325 */         row.createCell((short)10).setCellValue(bo.getFireeType());
/* 326 */         row.createCell((short)11).setCellValue(bo.getFireeIsEff());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForBathunder(HSSFSheet sheet, List list)
/*     */   {
/* 334 */     int count = list.size();
/* 335 */     if (count > 0)
/*     */     {
/* 337 */       String[] title = QueryContants.BATHUNDER_TITLE;
/* 338 */       HSSFRow rowTitle = sheet.createRow(0);
/* 339 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 341 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 343 */       for (int i = 0; i < count; i++)
/*     */       {
/* 345 */         BathunderBO bo = (BathunderBO)list.get(i);
/* 346 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 347 */         row.createCell((short)0).setCellValue(bo.getId());
/* 348 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 349 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 350 */         row.createCell((short)3).setCellValue(bo.getType());
/* 351 */         row.createCell((short)4).setCellValue(bo.getManufacturer());
/* 352 */         row.createCell((short)5).setCellValue(bo.getCapacity());
/* 353 */         row.createCell((short)6).setCellValue(bo.getNum());
/* 354 */         row.createCell((short)7).setCellValue(Contants.open.format(bo.getOpentime()));
/* 355 */         row.createCell((short)8).setCellValue(bo.getMaintenance());
/* 356 */         row.createCell((short)9).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 357 */         row.createCell((short)10).setCellValue(bo.getMemo());
/* 358 */         row.createCell((short)11).setCellValue(bo.getHunderPowerType());
/* 359 */         row.createCell((short)12).setCellValue(bo.getHunderWorkSta());
/* 360 */         row.createCell((short)13).setCellValue(bo.getHunderLineLen());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForEnvMontor(HSSFSheet sheet, List list)
/*     */   {
/* 369 */     int count = list.size();
/* 370 */     if (count > 0)
/*     */     {
/* 372 */       String[] title = QueryContants.ENVMONTOR_TITLE;
/* 373 */       HSSFRow rowTitle = sheet.createRow(0);
/* 374 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 376 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 378 */       for (int i = 0; i < count; i++)
/*     */       {
/* 380 */         EnvMontorBO bo = (EnvMontorBO)list.get(i);
/* 381 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 382 */         row.createCell((short)0).setCellValue(bo.getId());
/* 383 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 384 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 385 */         row.createCell((short)3).setCellValue(bo.getType());
/* 386 */         row.createCell((short)4).setCellValue(bo.getManufacturer());
/* 387 */         row.createCell((short)5).setCellValue(bo.getMonobj());
/* 388 */         row.createCell((short)6).setCellValue(bo.getTransType());
/* 389 */         row.createCell((short)7).setCellValue(bo.getTransPort());
/* 390 */         row.createCell((short)8).setCellValue(Contants.open.format(bo.getOpentime()));
/* 391 */         row.createCell((short)9).setCellValue(bo.getMaintenance());
/* 392 */         row.createCell((short)10).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 393 */         row.createCell((short)11).setCellValue(bo.getMemo());
/* 394 */         row.createCell((short)12).setCellValue(bo.getMonWorkSta());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForDynamo(HSSFSheet sheet, List list)
/*     */   {
/* 402 */     int count = list.size();
/* 403 */     if (count > 0)
/*     */     {
/* 405 */       String[] title = QueryContants.DYNAMO_TITLE;
/* 406 */       HSSFRow rowTitle = sheet.createRow(0);
/* 407 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 409 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 411 */       for (int i = 0; i < count; i++)
/*     */       {
/* 413 */         DynamoBO bo = (DynamoBO)list.get(i);
/* 414 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 415 */         row.createCell((short)0).setCellValue(bo.getId());
/* 416 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 417 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 418 */         row.createCell((short)3).setCellValue(bo.getManufacturer());
/* 419 */         row.createCell((short)4).setCellValue(bo.getType());
/* 420 */         row.createCell((short)5).setCellValue(bo.getModel());
/* 421 */         row.createCell((short)6).setCellValue(bo.getPower());
/* 422 */         row.createCell((short)7).setCellValue(bo.getAutoboot());
/* 423 */         row.createCell((short)8).setCellValue(bo.getConsumption());
/* 424 */         row.createCell((short)9).setCellValue(bo.getSumtime());
/* 425 */         row.createCell((short)10).setCellValue(bo.getMaintenance());
/* 426 */         row.createCell((short)11).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 427 */         row.createCell((short)12).setCellValue(bo.getMemo());
/* 428 */         row.createCell((short)13).setCellValue(bo.getDynamoIsStatic());
/* 429 */         row.createCell((short)14).setCellValue(bo.getDanymoSeiral());
/* 430 */         row.createCell((short)15).setCellValue(bo.getDynamoWorkLen());
/* 431 */         row.createCell((short)16).setCellValue(bo.getDynamoMaintainRec());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForAcdcDistribution(HSSFSheet sheet, List list)
/*     */   {
/* 439 */     int count = list.size();
/* 440 */     if (count > 0)
/*     */     {
/* 442 */       String[] title = QueryContants.ACDC_DISTRIBUTION_TITLE;
/* 443 */       HSSFRow rowTitle = sheet.createRow(0);
/* 444 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 446 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 448 */       for (int i = 0; i < count; i++)
/*     */       {
/* 450 */         AcdcDistributionBO bo = (AcdcDistributionBO)list.get(i);
/* 451 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 452 */         row.createCell((short)0).setCellValue(bo.getId());
/* 453 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 454 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 455 */         row.createCell((short)3).setCellValue(bo.getDistmanufacturer());
/* 456 */         row.createCell((short)4).setCellValue(bo.getDisttype());
/* 457 */         row.createCell((short)5).setCellValue(bo.getDistother());
/* 458 */         row.createCell((short)6).setCellValue(bo.getAirswitchM());
/* 459 */         row.createCell((short)7).setCellValue(bo.getAirswitchT());
/* 460 */         row.createCell((short)8).setCellValue(bo.getAirswitchC());
/* 461 */         row.createCell((short)9).setCellValue(bo.getAirswitchO());
/* 462 */         row.createCell((short)10).setCellValue(bo.getAirswitchCRD());
/* 463 */         row.createCell((short)11).setCellValue(bo.getElecableDAS());
/* 464 */         row.createCell((short)12).setCellValue(bo.getElecableDAT());
/* 465 */         row.createCell((short)13).setCellValue(bo.getElecableDANum());
/* 466 */         row.createCell((short)14).setCellValue(bo.getElecableDALen());
/* 467 */         row.createCell((short)15).setCellValue(bo.getElecableDACRD());
/* 468 */         row.createCell((short)16).setCellValue(bo.getRegulatorM());
/* 469 */         row.createCell((short)17).setCellValue(bo.getRegulatorT());
/* 470 */         row.createCell((short)18).setCellValue(bo.getRegulatorC());
/* 471 */         row.createCell((short)19).setCellValue(Contants.fresh.format(bo.getRegulatorOT()));
/* 472 */         row.createCell((short)20).setCellValue(bo.getRegulatorCRD());
/* 473 */         row.createCell((short)21).setCellValue(bo.getLighting());
/* 474 */         row.createCell((short)22).setCellValue(bo.getSocket());
/* 475 */         row.createCell((short)23).setCellValue(bo.getElecableCPS());
/* 476 */         row.createCell((short)24).setCellValue(bo.getElecableCPT());
/* 477 */         row.createCell((short)25).setCellValue(bo.getElecableCPNum());
/* 478 */         row.createCell((short)26).setCellValue(bo.getElecableCPLen());
/* 479 */         row.createCell((short)27).setCellValue(bo.getElecableCPCRD());
/* 480 */         row.createCell((short)28).setCellValue(bo.getDDConverterT());
/* 481 */         row.createCell((short)29).setCellValue(bo.getDDConverterM());
/* 482 */         row.createCell((short)30).setCellValue(bo.getDDConverterNum());
/* 483 */         row.createCell((short)31).setCellValue(bo.getDDConverterC());
/* 484 */         row.createCell((short)32).setCellValue(Contants.fresh.format(bo.getDDConverterOT()));
/* 485 */         row.createCell((short)33).setCellValue(bo.getDDConverterCRD());
/* 486 */         row.createCell((short)34).setCellValue(bo.getDDisplayT());
/* 487 */         row.createCell((short)35).setCellValue(bo.getDDisplayM());
/* 488 */         row.createCell((short)36).setCellValue(bo.getDDisplayNum());
/* 489 */         row.createCell((short)37).setCellValue(bo.getDDisplayC());
/* 490 */         row.createCell((short)38).setCellValue(Contants.fresh.format(bo.getDDisplayOT()));
/* 491 */         row.createCell((short)39).setCellValue(bo.getMaintenance());
/* 492 */         row.createCell((short)40).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 493 */         row.createCell((short)41).setCellValue(bo.getMemo());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForTransformer(HSSFSheet sheet, List list)
/*     */   {
/* 501 */     int count = list.size();
/* 502 */     if (count > 0)
/*     */     {
/* 504 */       String[] title = QueryContants.TRANS_FORMER_TITLE;
/* 505 */       HSSFRow rowTitle = sheet.createRow(0);
/* 506 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 508 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 510 */       for (int i = 0; i < count; i++)
/*     */       {
/* 512 */         TransformerBO bo = (TransformerBO)list.get(i);
/* 513 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 514 */         row.createCell((short)0).setCellValue(bo.getId());
/* 515 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 516 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 517 */         row.createCell((short)3).setCellValue(bo.getModel());
/* 518 */         row.createCell((short)4).setCellValue(bo.getCapacity());
/* 519 */         row.createCell((short)5).setCellValue(bo.getManufacturer());
/* 520 */         row.createCell((short)6).setCellValue(bo.getProperty());
/* 521 */         row.createCell((short)7).setCellValue(bo.getMaintenance());
/* 522 */         row.createCell((short)8).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 523 */         row.createCell((short)9).setCellValue(bo.getMemo());
/* 524 */         row.createCell((short)10).setCellValue(bo.getTranPowerType());
/* 525 */         row.createCell((short)11).setCellValue(bo.getTranMaintain());
/* 526 */         row.createCell((short)12).setCellValue(bo.getTranHighLen());
/* 527 */         row.createCell((short)13).setCellValue(bo.getTranLowLen());
/* 528 */         row.createCell((short)14).setCellValue(bo.getTranRValue());
/* 529 */         row.createCell((short)15).setCellValue(bo.getTranStartTime());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForTransfers(HSSFSheet sheet, List list)
/*     */   {
/* 537 */     int count = list.size();
/* 538 */     if (count > 0)
/*     */     {
/* 540 */       String[] title = QueryContants.TRANSFERS_TITLE;
/* 541 */       HSSFRow rowTitle = sheet.createRow(0);
/* 542 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 544 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 546 */       for (int i = 0; i < count; i++)
/*     */       {
/* 548 */         TransfersBO bo = (TransfersBO)list.get(i);
/* 549 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 550 */         row.createCell((short)0).setCellValue(bo.getId());
/* 551 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 552 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 553 */         row.createCell((short)3).setCellValue(bo.getTransAF());
/* 554 */         row.createCell((short)4).setCellValue(bo.getSDHAF());
/* 555 */         row.createCell((short)5).setCellValue(bo.getPDHAF());
/* 556 */         row.createCell((short)6).setCellValue(bo.getMicrowaveAF());
/* 557 */         row.createCell((short)7).setCellValue(bo.getOtherAF());
/* 558 */         row.createCell((short)8).setCellValue(bo.getSDHAM());
/* 559 */         row.createCell((short)9).setCellValue(bo.getPDHAM());
/* 560 */         row.createCell((short)10).setCellValue(bo.getMicrowaveAM());
/* 561 */         row.createCell((short)11).setCellValue(bo.getOtherAM());
/* 562 */         row.createCell((short)12).setCellValue(bo.getVoltageA());
/* 563 */         row.createCell((short)13).setCellValue(bo.getPropertyA());
/* 564 */         row.createCell((short)14).setCellValue(Contants.open.format(bo.getOpentimeA()));
/* 565 */         row.createCell((short)15).setCellValue(bo.getDistODFAF());
/* 566 */         row.createCell((short)16).setCellValue(bo.getDistDDFAF());
/* 567 */         row.createCell((short)17).setCellValue(bo.getDistcomtankAF());
/* 568 */         row.createCell((short)18).setCellValue(bo.getDistotherAF());
/* 569 */         row.createCell((short)19).setCellValue(bo.getDistODFAM());
/* 570 */         row.createCell((short)20).setCellValue(bo.getDistDDFAM());
/* 571 */         row.createCell((short)21).setCellValue(bo.getDistcomtankAM());
/* 572 */         row.createCell((short)22).setCellValue(bo.getDistotherAM());
/* 573 */         row.createCell((short)23).setCellValue(bo.getEle2MCNum());
/* 574 */         row.createCell((short)24).setCellValue(bo.getEle2MUNum());
/* 575 */         row.createCell((short)25).setCellValue(bo.getEle2MAUNum());
/* 576 */         row.createCell((short)26).setCellValue(bo.getEle2MUidx());
/* 577 */         row.createCell((short)27).setCellValue(bo.getEle2MUTimeSlot());
/* 578 */         row.createCell((short)28).setCellValue(bo.getMaintenance());
/* 579 */         row.createCell((short)29).setCellValue(Contants.fresh.format(bo.getOpentimeA()));
/* 580 */         row.createCell((short)30).setCellValue(bo.getMemo());
/* 581 */         row.createCell((short)31).setCellValue(bo.getStr2MUseSta());
/* 582 */         row.createCell((short)32).setCellValue(bo.getIsPowerAlone());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForMainssupply(HSSFSheet sheet, List list)
/*     */   {
/* 592 */     int count = list.size();
/* 593 */     if (count > 0)
/*     */     {
/* 595 */       String[] title = QueryContants.MAIN_SUPPLY_TITLE;
/* 596 */       HSSFRow rowTitle = sheet.createRow(0);
/* 597 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 599 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 601 */       for (int i = 0; i < count; i++)
/*     */       {
/* 603 */         MainssupplyBO bo = (MainssupplyBO)list.get(i);
/* 604 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 605 */         row.createCell((short)0).setCellValue(bo.getId());
/* 606 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 607 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 608 */         row.createCell((short)3).setCellValue(bo.getType());
/* 609 */         row.createCell((short)4).setCellValue(bo.getElecableTDLen());
/* 610 */         row.createCell((short)5).setCellValue(bo.getElecableTDM());
/* 611 */         row.createCell((short)6).setCellValue(bo.getElecableTDT());
/* 612 */         row.createCell((short)7).setCellValue(bo.getElecableTDP());
/* 613 */         row.createCell((short)8).setCellValue(bo.getElecableLDLen());
/* 614 */         row.createCell((short)9).setCellValue(bo.getElecableLDM());
/* 615 */         row.createCell((short)10).setCellValue(bo.getElecableLDT());
/* 616 */         row.createCell((short)11).setCellValue(bo.getElecableLDP());
/* 617 */         row.createCell((short)12).setCellValue(bo.getMaintenance());
/* 618 */         row.createCell((short)13).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 619 */         row.createCell((short)14).setCellValue(bo.getMemo());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForAntennaFeeder(HSSFSheet sheet, List list)
/*     */   {
/* 627 */     int count = list.size();
/* 628 */     if (count > 0)
/*     */     {
/* 630 */       String[] title = QueryContants.ANTENNA_FEEDER_TITLE;
/* 631 */       HSSFRow rowTitle = sheet.createRow(0);
/* 632 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 634 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 636 */       for (int i = 0; i < count; i++)
/*     */       {
/* 638 */         AntennaFeederBO bo = (AntennaFeederBO)list.get(i);
/* 639 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 640 */         row.createCell((short)0).setCellValue(bo.getId());
/* 641 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 642 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 643 */         row.createCell((short)3).setCellValue(bo.getAntennaT());
/* 644 */         row.createCell((short)4).setCellValue(bo.getAntennaM());
/* 645 */         row.createCell((short)5).setCellValue(bo.getAntennaNum());
/* 646 */         row.createCell((short)6).setCellValue(bo.getAntennaPlu());
/* 647 */         row.createCell((short)7).setCellValue(bo.getAntennaDir());
/* 648 */         row.createCell((short)8).setCellValue(bo.getAntennaPT());
/* 649 */         row.createCell((short)9).setCellValue(bo.getAntennaFB());
/* 650 */         row.createCell((short)10).setCellValue(bo.getAntennaH());
/* 651 */         row.createCell((short)11).setCellValue(bo.getAntennaCRD());
/* 652 */         row.createCell((short)12).setCellValue(bo.getMagnifierT());
/* 653 */         row.createCell((short)13).setCellValue(bo.getMagnifierM());
/* 654 */         row.createCell((short)14).setCellValue(bo.getMagnifierNum());
/* 655 */         row.createCell((short)15).setCellValue(bo.getMagnifierCell());
/* 656 */         row.createCell((short)16).setCellValue(bo.getMagnifierCRD());
/* 657 */         row.createCell((short)17).setCellValue(bo.getFeederT());
/* 658 */         row.createCell((short)18).setCellValue(bo.getFeederM());
/* 659 */         row.createCell((short)19).setCellValue(bo.getFeederLen());
/* 660 */         row.createCell((short)20).setCellValue(bo.getFeederNum());
/* 661 */         row.createCell((short)21).setCellValue(bo.getMaintenance());
/* 662 */         row.createCell((short)22).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 663 */         row.createCell((short)23).setCellValue(bo.getMemo());
/* 664 */         row.createCell((short)24).setCellValue(bo.getAnteIsMakeAng());
/* 665 */         row.createCell((short)25).setCellValue(bo.getAnteDicAng());
/* 666 */         row.createCell((short)26).setCellValue(bo.getAnteUpAng());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForIronTower(HSSFSheet sheet, List list)
/*     */   {
/* 674 */     int count = list.size();
/* 675 */     if (count > 0)
/*     */     {
/* 677 */       String[] title = QueryContants.IRON_TOWER_TITLE;
/* 678 */       HSSFRow rowTitle = sheet.createRow(0);
/* 679 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 681 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 683 */       for (int i = 0; i < count; i++)
/*     */       {
/* 685 */         IronTowerBO bo = (IronTowerBO)list.get(i);
/* 686 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 687 */         row.createCell((short)0).setCellValue(bo.getId());
/* 688 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 689 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 690 */         row.createCell((short)3).setCellValue(bo.getProperty());
/* 691 */         row.createCell((short)4).setCellValue(Contants.open.format(bo.getOpentime()));
/* 692 */         row.createCell((short)5).setCellValue(bo.getFromunit());
/* 693 */         row.createCell((short)6).setCellValue(bo.getContact());
/* 694 */         row.createCell((short)7).setCellValue(bo.getTelphone());
/* 695 */         row.createCell((short)8).setCellValue(bo.getType());
/* 696 */         row.createCell((short)9).setCellValue(bo.getHeight());
/* 697 */         row.createCell((short)10).setCellValue(bo.getWarnschilder());
/* 698 */         row.createCell((short)11).setCellValue(bo.getMaintenance());
/* 699 */         row.createCell((short)12).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 700 */         row.createCell((short)13).setCellValue(bo.getMemo());
/* 701 */         row.createCell((short)14).setCellValue(bo.getItowerPlatNum());
/* 702 */         row.createCell((short)15).setCellValue(bo.getItowerSta());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForMachineRoom(HSSFSheet sheet, List list)
/*     */   {
/* 709 */     int count = list.size();
/* 710 */     if (count > 0)
/*     */     {
/* 712 */       String[] title = QueryContants.MACHINE_ROOM_TITLE;
/* 713 */       HSSFRow rowTitle = sheet.createRow(0);
/* 714 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 716 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 718 */       for (int i = 0; i < count; i++)
/*     */       {
/* 720 */         MachineRoomBO bo = (MachineRoomBO)list.get(i);
/* 721 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 722 */         row.createCell((short)0).setCellValue(bo.getId());
/* 723 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 724 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 725 */         row.createCell((short)3).setCellValue(bo.getFrame());
/* 726 */         row.createCell((short)4).setCellValue(bo.getAcreageT());
/* 727 */         row.createCell((short)5).setCellValue(bo.getPlan());
/* 728 */         row.createCell((short)6).setCellValue(bo.getProperty());
/* 729 */         row.createCell((short)7).setCellValue(bo.getFromunit());
/* 730 */         row.createCell((short)8).setCellValue(bo.getOther());
/* 731 */         row.createCell((short)9).setCellValue(bo.getContact());
/* 732 */         row.createCell((short)10).setCellValue(bo.getTelphone());
/* 733 */         row.createCell((short)11).setCellValue(Contants.open.format(bo.getOpentime()));
/* 734 */         row.createCell((short)12).setCellValue(bo.getWallheight());
/* 735 */         row.createCell((short)13).setCellValue(bo.getDoortype());
/* 736 */         row.createCell((short)14).setCellValue(bo.getFacility());
/* 737 */         row.createCell((short)15).setCellValue(bo.getReason());
/* 738 */         row.createCell((short)16).setCellValue(bo.getWarnschilder());
/* 739 */         row.createCell((short)17).setCellValue(bo.getAcreageU());
/* 740 */         row.createCell((short)18).setCellValue(bo.getPlace());
/* 741 */         row.createCell((short)19).setCellValue(bo.getMaintenance());
/*     */ 
/* 743 */         row.createCell((short)20).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 744 */         row.createCell((short)21).setCellValue(bo.getMemo());
/* 745 */         row.createCell((short)22).setCellValue(bo.getMroomIsLook());
/*     */ 
/* 747 */         row.createCell((short)23).setCellValue(bo.getMroomLookTel());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForPowerSupply(HSSFSheet sheet, List list)
/*     */   {
/* 755 */     int count = list.size();
/* 756 */     if (count > 0)
/*     */     {
/* 758 */       String[] title = QueryContants.POWER_SUPPLY_TITLE;
/* 759 */       HSSFRow rowTitle = sheet.createRow(0);
/* 760 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 762 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 764 */       for (int i = 0; i < count; i++)
/*     */       {
/* 766 */         PowerSupplyBO bo = (PowerSupplyBO)list.get(i);
/* 767 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 768 */         row.createCell((short)0).setCellValue(bo.getId());
/* 769 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 770 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 771 */         row.createCell((short)3).setCellValue(bo.getPowersupply());
/* 772 */         row.createCell((short)4).setCellValue(bo.getPstelephone());
/* 773 */         row.createCell((short)5).setCellValue(bo.getContact());
/* 774 */         row.createCell((short)6).setCellValue(bo.getTelephone());
/* 775 */         row.createCell((short)7).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 776 */         row.createCell((short)8).setCellValue(bo.getMemo());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForTrafficInfo(HSSFSheet sheet, List list)
/*     */   {
/* 783 */     int count = list.size();
/* 784 */     if (count > 0)
/*     */     {
/* 786 */       String[] title = QueryContants.TRAFFIC_INFO_TITLE;
/* 787 */       HSSFRow rowTitle = sheet.createRow(0);
/* 788 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 790 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 792 */       for (int i = 0; i < count; i++)
/*     */       {
/* 794 */         TrafficInfoBO bo = (TrafficInfoBO)list.get(i);
/* 795 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 796 */         row.createCell((short)0).setCellValue(bo.getId());
/* 797 */         row.createCell((short)1).setCellValue(bo.getBtscode());
/* 798 */         row.createCell((short)2).setCellValue(bo.getBtsname());
/* 799 */         row.createCell((short)3).setCellValue(bo.getRoad());
/* 800 */         row.createCell((short)4).setCellValue(bo.getDistanceC());
/* 801 */         row.createCell((short)5).setCellValue(bo.getArrivaltimeC());
/* 802 */         row.createCell((short)6).setCellValue(bo.getDistanceP());
/* 803 */         row.createCell((short)7).setCellValue(bo.getArrivaltimeP());
/* 804 */         row.createCell((short)8).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 805 */         row.createCell((short)9).setCellValue(bo.getMemo());
/*     */       }
/*     */     }
/*     */   }
/*     */ 
/*     */   public static void wirteToExcelForEnv(HSSFSheet sheet, List list)
/*     */   {
/* 812 */     int count = list.size();
/* 813 */     if (count > 0)
/*     */     {
/* 815 */       String[] title = QueryContants.ENV_INFO_TITLE;
/* 816 */       HSSFRow rowTitle = sheet.createRow(0);
/* 817 */       for (int i = 0; i < title.length; i++)
/*     */       {
/* 819 */         rowTitle.createCell((short)i).setCellValue(title[i]);
/*     */       }
/* 821 */       for (int i = 0; i < count; i++)
/*     */       {
/* 823 */         GeographicalenvBo bo = (GeographicalenvBo)list.get(i);
/* 824 */         HSSFRow row = sheet.createRow((short)i + 1);
/* 825 */         row.createCell((short)0).setCellValue(bo.getBtscode());
/* 826 */         row.createCell((short)1).setCellValue(bo.getBtsname());
/* 827 */         row.createCell((short)2).setCellValue(bo.getBtszone());
/* 828 */         row.createCell((short)3).setCellValue(bo.getLandform());
/* 829 */         row.createCell((short)4).setCellValue(bo.getLng());
/* 830 */         row.createCell((short)5).setCellValue(bo.getLat());
/* 831 */         row.createCell((short)6).setCellValue(bo.getRelocationrd());
/* 832 */         row.createCell((short)7).setCellValue(bo.getUsername());
/* 833 */         row.createCell((short)8).setCellValue(bo.getDistcode());
/* 834 */         row.createCell((short)9).setCellValue(bo.getBtslevel());
/* 835 */         row.createCell((short)10).setCellValue(bo.getWorkingradius());
/* 836 */         row.createCell((short)11).setCellValue(bo.getGraphDeatilAddr());
/* 837 */         row.createCell((short)12).setCellValue(bo.getGraphHigh());
/* 838 */         row.createCell((short)13).setCellValue(bo.getTrannetid());
/* 839 */         row.createCell((short)14).setCellValue(bo.getTrannetname());
/* 840 */         row.createCell((short)15).setCellValue(bo.getTrannetgrade());
/* 841 */         row.createCell((short)16).setCellValue(Contants.fresh.format(bo.getRegisttime()));
/* 842 */         row.createCell((short)17).setCellValue(bo.getBtskind());
/* 843 */         row.createCell((short)18).setCellValue(bo.getBtstype());
/* 844 */         row.createCell((short)19).setCellValue(bo.getCoverage());
/* 845 */         row.createCell((short)20).setCellValue(bo.getMaintype());
/* 846 */         row.createCell((short)21).setCellValue(Contants.fresh.format(bo.getRefreshtime()));
/* 847 */         row.createCell((short)22).setCellValue(bo.getMemo());
/*     */       }
/*     */     }
/*     */   }
/*     */ }

/* Location:           E:\java\apache-tomcat-6.0.36\webapps\btsm\WEB-INF\classes\
 * Qualified Name:     com.yc.web.export.ExportUtil
 * JD-Core Version:    0.6.2
 */